# ADO Type Property

Complete Parameter Object Reference

The Type property sets or returns a DataTypeEnum value that indicates the type of a Parameter, Field, or a Property object.

Object | Description of the Type Property
--- | ---
Parameter | The Type property has read/write permissions on a Parameter object
Field | The Type property is read/write, with one exception; for new Field objects that are added to the Fields collection of a Record, this property is read-only before the Value property has been set and before the provider has called the Update method of the Fields collection
Property | The Type property is read-only for a Property object

### Syntax

objectname.Type

### Example - For a Field object

<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"
set rs = Server.CreateObject("ADODB.Recordset")
rs.open "Select * from orders", conn
response.write(rs.Fields(0).Type)
rs.Close
conn.close
%>

### Example - For a Parameter object

<%
set comm=Server.CreateObject("ADODB.Command")
set para=Server.CreateObject("ADODB.Parameter")
para.Type=adVarChar
para.Size=25
para.Direction=adParamInput
para.Value=varfname
comm.Parameters.Append para
%>

### Example - For a Property object

<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"
set rs = Server.CreateObject("ADODB.Recordset")
rs.open "Select * from orders", conn
set prop=Server.CreateObject("ADODB.Property")
'Display the property attributes of the Orders Table
for each prop in rs.Properties
response.write("Attr:" & prop.Attributes & "<br>")
response.write("Name:" & prop.Name & "<br>")
response.write("Value:" & prop.Value & "<br>")
next
rs.close
conn.close
set rs=nothing
set conn=nothing
%>

### DataTypeEnum Values

Specifies the data type of a Field, Parameter, or Property object

Constant | Value | Description
--- | --- | ---
adEmpty | 0 | No value
adSmallInt | 2 | A 2-byte signed integer.
adInteger | 3 | A 4-byte signed integer.
adSingle | 4 | A single-precision floating-point value.
adDouble | 5 | A double-precision floating-point value.
adCurrency | 6 | A currency value
adDate | 7 | The number of days since December 30, 1899 + the fraction of a day.
adBSTR | 8 | A null-terminated character string.
adIDispatch | 9 | A pointer to an IDispatch interface on a COM object. Note: Currently not supported by ADO.
adError | 10 | A 32-bit error code
adBoolean | 11 | A boolean value.
adVariant | 12 | An Automation Variant. Note: Currently not supported by ADO.
adIUnknown | 13 | A pointer to an IUnknown interface on a COM object. Note: Currently not supported by ADO.
adDecimal | 14 | An exact numeric value with a fixed precision and scale.
adTinyInt | 16 | A 1-byte signed integer.
adUnsignedTinyInt | 17 | A 1-byte unsigned integer.
adUnsignedSmallInt | 18 | A 2-byte unsigned integer.
adUnsignedInt | 19 | A 4-byte unsigned integer.
adBigInt | 20 | An 8-byte signed integer.
adUnsignedBigInt | 21 | An 8-byte unsigned integer.
adFileTime | 64 | The number of 100-nanosecond intervals since January 1,1601
adGUID | 72 | A globally unique identifier (GUID)
adBinary | 128 | A binary value.
adChar | 129 | A string value.
adWChar | 130 | A null-terminated Unicode character string.
adNumeric | 131 | An exact numeric value with a fixed precision and scale.
adUserDefined | 132 | A user-defined variable.
adDBDate | 133 | A date value (yyyymmdd).
adDBTime | 134 | A time value (hhmmss).
adDBTimeStamp | 135 | A date/time stamp (yyyymmddhhmmss plus a fraction in billionths).
adChapter | 136 | A 4-byte chapter value that identifies rows in a child rowset
adPropVariant | 138 | An Automation PROPVARIANT.
adVarNumeric | 139 | A numeric value (Parameter object only).
adVarChar | 200 | A string value (Parameter object only).
adLongVarChar | 201 | A long string value.
adVarWChar | 202 | A null-terminated Unicode character string.
adLongVarWChar | 203 | A long null-terminated Unicode string value.
adVarBinary | 204 | A binary value (Parameter object only).
adLongVarBinary | 205 | A long binary value.
AdArray | 0x2000 | A flag value combined with another data type constant. Indicates an array of that other data type.

Complete Parameter Object Reference

### WEB HOSTING

UK Reseller Hosting

### WEB BUILDING

FREE Website BUILDER Free HTML5 Templates

### W3SCHOOLS EXAMS

HTML, CSS, JavaScript, PHP, jQuery, XML, and ASP Certifications

### SHARE THIS PAGE

### Color Picker

### HTML/CSS

HTML Tutorial HTML5 Tutorial CSS Tutorial CSS3 Tutorial Bootstrap Tutorial

### JavaScript

JavaScript Tutorial jQuery Tutorial jQuery Mobile Tutorial AngularJS Tutorial AJAX Tutorial JSON Tutorial

### Graphics

Canvas Tutorial SVG Tutorial Google Maps Tutorial

### Server Side

SQL Tutorial PHP Tutorial ASP Tutorial ASP.NET Tutorial VBScript Tutorial AppML Tutorial

### Web

Web Building Web Statistics Web Certification

### XML

XML Tutorial DTD Tutorial Schema Tutorial XML DOM Tutorial XPath Tutorial XSLT Tutorial XQuery Tutorial XSL-FO Tutorial RSS Tutorial WSDL Tutorial

### HTML/CSS

HTML Tag Reference HTML Event Reference HTML Color Reference CSS 1,2,3 Reference Bootstrap Reference

### JavaScript

JavaScript Reference HTML DOM Reference jQuery Reference jQuery Mobile Reference Google Maps Reference

### Server Side

PHP Reference SQL Reference ASP Reference VBScript Reference Razor Reference ASP.NET Reference

### XML

XML DOM Reference XSLT Reference XSL-FO Reference XPath Reference XQuery Reference Schema Reference RSS Reference SVG Reference

### HTML Charsets

HTML Character Sets HTML ASCII HTML ANSI HTML Windows-1252 HTML ISO-8859-1 HTML Symbols HTML UTF-8

### HTML/CSS

HTML Examples CSS Examples

### Browser Scripting

JavaScript Examples HTML DOM Examples jQuery Examples jQuery Mobile Examples AngularJS Examples AJAX Examples

### Server Scripting

PHP Examples ASP Examples VBScript Examples Razor Examples .NET Examples

### XML Languages

XML Examples DTD Examples XML DOM Examples XSL Examples XSLT Examples XPath Examples XQuery Examples Schema Examples RSS Examples SVG Examples